
--CREATE ROLE, and GRANT statements

CREATE ROLE AdvisorRole;
CREATE ROLE FacultyRole;

GRANT SELECT ON Student TO AdvisorRole;
GRANT SELECT, UPDATE ON Enroll TO AdvisorRole;
GRANT SELECT ON Enroll TO FacultyRole;

CREATE USER U990 identified by SESAME1;
CREATE USER U111 identified by SESAME2;

GRANT AdvisorRole TO U990;

GRANT FacultyRole TO AdvisorRole;

